Community

Hi

I would like to delete everything between delimiter in each line.
sample...
þþþþþþþ000000001A6F87258ECABF42A145ECD486D2EF6E24002000þþc4ad4c39f9529dc1d518571945c02d2cþ
þþþþþþþ000000001A6F87258ECABF42A145ECD486D2EF6E44002000þþ2decd1417925927ccb218af0fd6a5b58þ ...

I need to take out everything from the , to the right.

EC06919B0150355,EC06919B0150420,066
EC06919B0151231,EC06919B0151601.1,372
EC06919B0151602,EC06919B0151602,001
EC000301523,EC000301641,119
ECg004021003,ECg004028702,7700

solution
EC06919B0150355
EC06919B0151231
EC06919B0151602
EC000301523 ...

you guy are great.

Hi

I only need the data btween the ",".

EC06919B0150355,EC06919B0150420,066
EC06919B0151231,EC06919B0151601.1,372
EC06919B0151602,EC06919B0151602,001
EC000301523,EC000301641,119
ECg004021003,ECg004028702,7700

should be
EC06919B0150420
EC06919B0151601.1
EC06919B0151602
EC000301641
ECg004028702 ...

thanks

Hi

I need to delete from the "\" to the ";", but dont want the semicolon to be delete.

Export002\AIG 005647-AIG 005647;AIG 005647-AIG 005647.T
Export00200\AIG 005648-AIG 005648;AIG 005648-AIG 005648.T
Export0022\AIG 005649-AIG 005649;AIG 005649-AIG 005649.T

to look like this...

Export002;AIG ...

that work and Thank You for the quick reply.

yes sir

Thanks

Hi

I need help deleting a files with these lines...

1120,"Alvarez, Carlos","6076","Non-Responsive","6075","Autoriz Operac 1117,"Alvarez, Carlos","6073","Responsive","6073","Msg0020_DCF Plan
6,"Alvarez, Carlos","1013","Non-Responsive","1013
176,"Gabarro, Salvador","2200","Non-Responsive","2200 ...

how can i delete the everything from "errored" to the end of the path using regluar expression?

\\06_Pmt_scheme__7_aircraft.xls","Errored","Adelphia_1999_2003_180536",""

output=\06_Pmt_scheme__7_aircraft.xls",

Thanks for the help

Hi, I have this path that i need only the file name and extension at the end of the path.

example:
\\dct02\abc\Bennett_1_050823\C_Drive1\Documents and Settings\Administrator\NTUSER.DAT

outcome should be...

NTUSER.DAT


Thanks