Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
i have data in notepad shown below
Sample1:
eid|name|salary
123|ravi|100
234|arun|200
345|rathish|300
456|rohit|400
sample2:
barcode|value
000001|10000
0 1012|20000
00 111|30000
002222|30000
000088|40000
now what i want ...table should seen like this
eid | |
123 | |
234 | |
345 | |
456 |
same for others....plz help me
thanks rohit
edit script-> Table Files-> select the text file-> delimeter-.Custom-> then seach for '|' and select '|'
-> next-> next -...finish
reload the application
now you have 3 fields
Eid, Name and salary
hope this heelps
while loading you can write
load
subfield(fieldname,'|',1) as EID,
subfield(fieldname,'|',2) as Name,
subfield(fieldname,'|',3) as salary
from abc.text
hi sunil
its give only the EID
remaining shows no values
thanks
rohit
Hi,
Please upload ur application
Hi,
In your script select the data file using the 'Table Files' option. Set File Type=Delimited, Delimiter = Custom = '|'. And follow further steps and load data.
Hope this helps.
Thanks.
edit script-> Table Files-> select the text file-> delimeter-.Custom-> then seach for '|' and select '|'
-> next-> next -...finish
reload the application
now you have 3 fields
Eid, Name and salary
hope this heelps
Hear '123455' this is string formate time .hear how to use delimete ,i.e.time is 12-34-55 whate is function used for written delimeter replay fast friends
Try below
Left('123455',2)&'-'&mid('123455',3,2)&'-'&right('123455',2) as time