Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have input file like this.
eno | ename | sal | hra | dno |
100 | MaHKKh | 1112 | 1200 | 10 |
101 | Ma"Hesh" | 1007 | 8888 | 10 |
102 | kalyan | 9999 | 1000 | 10 |
103 | kal123 | 8882 | 1544 | 21 |
110 | Nagraj | 1112 | 1000 | 21 |
111 | Nagnnn | 5555 | 1004 | 21 |
112 | Nagaaa | 24400 | 540 | 21 |
how can i remove quotation marks in ename field while reading csv file?
Hi @prasan,
Have u tried Replace functions in tmap expression editor?
No i didn't try with tmap,
i am reading csv file by using tfileinputdelimited how can i set escape char or text enclosure in advanced settings.
Hi @prasan,
You can try with treplace also. in tReplace name the Column,In the search for Keep """ and keep nothing in to be replaced column and try