Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to split a column with | delimited string in to multiple columns. I am using tExtractDelimitedFields to split.
But when i set "|" as field separator then it gives below wrong output.
skill1|skill2|skill3|id
j|a|v|a|1
d|o|t|n|2
e|r|l|a|3
Correct output needs to be
skill1|skill2|skill3|id
java|python|go|1
dotnet|r|ruby|2
erlang|graph|cobra
My original file is as below
id;delimiteddata
1;java|python|go
2;dotnet|r|ruby
3;erlang|graph|cobra
And if i dont use | as delimiter in my file and use comma, then it works correctly
Thanks
Hemant
@not specified not specified , use "\\|" as a field separator in tExtractDelimitedFields ,it will work.
check the below link to know more about it.
Thanks,
Manohar
@not specified not specified , use "\\|" as a field separator in tExtractDelimitedFields ,it will work.
check the below link to know more about it.
Thanks,
Manohar
Thanks @Manohar B Manohar
It works
Thanks,
Hemant