deleting a 'tab' in certain situation

dbibel · Aug 30, 2006#12006-08-30T17:56+00:00

Hi:

I have a tab-delimited file that I need to work on.

In some cases, there is a number - tab - number sequence.

In other cases, there is a number - tab - alpha character or 'space' sequence.

In the first case, I'd like to delete the tab and concatenate the two numbers together.

In the second case, I'd like to just delete the tab.

I'm sure there is a way to do this, but I would v. much appreciate any help.

Thanks!

db

Mofi · Aug 30, 2006#22006-08-30T18:09+00:00

With an UltraEdit style regex (see Configuration - Search - Regular Expression Engine):

For "number - tab - number sequence":

Find: ^([0-9]^) - ^t - ^([0-9]^)
Replace: ^1^2

For "number - tab - alpha character or 'space' sequence":

Find: ^([0-9]^) - ^t - ^([~0-9^p]^)
Replace: ^1 - ^2

See help of UltraEdit about the Find command and Regular Expressions to understand this regexp strings or convert it to Unix/Perl style.

If this is not exactly what you need, your examples where not exact.