Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Here is the table loaded.
Sample:
LOAD * INLINE [
S.No, Region
1, USA.Atlanta
2, USA.California
3, USA.California.Bayarea
4, India.Karnataka.Tamilnadu.Chennai
];
Now the requirement is to replace . with space(" ")
Region
USA Atlanta
USA California
USA California Bayarea
India Karnataka Tamilnadu chennai
Can please one please let me know any function to use.
May be this?
Sample:
LOAD [S.No], Replace(Region,'.',' ') as Region INLINE [
S.No, Region
1, USA.Atlanta
2, USA.California
3, USA.California.Bayarea
4, India.Karnataka.Tamilnadu.Chennai
];
May be this?
Sample:
LOAD [S.No], Replace(Region,'.',' ') as Region INLINE [
S.No, Region
1, USA.Atlanta
2, USA.California
3, USA.California.Bayarea
4, India.Karnataka.Tamilnadu.Chennai
];
Replace(Region, '.',' ') as NewRegion
Another option
Mapping:
Mapping
LOAD * Inline [
Find, Replace
., " "
];
Sample:
LOAD S.No,
MapSubString('Mapping', Region) as Region;
LOAD * INLINE [
S.No, Region
1, USA.Atlanta
2, USA.California
3, USA.California.Bayarea
4, India.Karnataka.Tamilnadu.Chennai
];
Thank you so much @Anil tresesco
Thank you @sunny