Search Results

Sorry Shell, I tried to come up with every situation in my head, but missed that one scenario. I'm trying to come up with a solution without having an actual test file from my customer yet, trying...

That worked for the sample that I gave you, but I thought of another scenario that I need to account for. What would happen if I added another comma to the end and then some more text? Sample -
...

I was wondering if somebody could help me with something on UNIX. I have a file that looks like this -

"nelson,bill","bill","123 Main St","Mpls","MN",55444,8877,william

I want to replace all...

I'm sorry, I should have explain it better. As I was trying to work with more data and more files I ran into this new scenario. I maybe should have opened a new thread, but I wasn't sure. This is...

Here is a very small sample file with 3 fields. The first record has data in field 1 and field 3 and the 2nd field is empty and the second record has data in field 1 and 2 and field 3 is empty.

I still seem to be getting the same results as before. I have dug through every book I have and I cant figure out how to fix this. It's still skipping over empty fields instead of setting them to...

I thought I had this figured out, but I'm running into another scenario that I need help with. Do you know how I can fix this if I have no data in a field, <<tab>><<tab>>? What is happening is that...

Thanks for your help.

Thanks for that help, that got me most of the way to where I needed. Do you know how to do the NULL padding after the strings instead of space padding? I thought I figured it out with a -Z on the...

Hi, I have to change a tab delimited file to a fixed length file. For text fields I need to left justify and NULL fill to the right and for number fields I need to right justify and zero fill to the...

Sorry about that, good idea. Here's my solution -
grep -v '^.\{48\}[[:space:]].*[[:space:]].*[[:space:]].*' <infile> > <outfile>

You can never mind this question, I figured it out.

I was wondering if anybody can help me with this. I have the following code to look for a space in position #48 and I want to change it so it looks in position 48, 59, and 50 for spaces. How can I...