Hi Experts,
I have a txt file that is in the format as below.
Trade Name Date CurrencyAmount
1 XXXXDDMMYYUSD-YYYYY
2 XXXXDDMMYYUSD-YYYYY
3 XXXXDDMMYYUSD-YYYYY
and so forth.
First I want to split the headers in to appropriate delimiters, in this case
TradeName Date Currency Amount
In addition I want to delimit the datasets but there are no spaces in between. The only delimiter present is the - between the currency and the amount. Can you please help me to place the correct dataset in the correct column. Thank you very much in advance.
Solved! Go to Solution.
Can you provide a sample dataset so we can understand your data format for parsing.
For the dataset, we can parse like this.
But for the header, it will be very challenging since there is obvious pattern there.
Do you allow manully naming columns?