Adding delimiters

[brooklyn1976]

Not sure if this is an Excel question per se, but hopefully someone can point me in the right direction.


I have received two txt files, lets call them “F” and “P.”


F contains 1372 lines each with approximately 330 characters (including spaces).
P contains 302 lines each with approximately 353 characters (including spaces).


The files contain data that should be broken into columns, but the files do not contain any delimiters so I cannot import into Excel until I add them to the files.


Is there a program or script i can use to add delimiters at the same locations on each line of the files.


I am using a Mac and have minimal experience with VBA. Any help is greatly appreciated. Thanks!!


For “F” I want a delimiter after the following characters on each line:
12
20
26
32
44
46
50
54
62
74
83
85
92
101
110
117
124
133
135
142
149
156
163
170
178
185
190
201
202
203
204
205
209
210
211
212
219
226
227
236
238
240
247
254
261
270
282
293
304
315
326




For “P”:
12
20
22
26
30
37
38
44
54
66
75
77
84
93
102
111
118
125
127
134
141
148
155
162
169
177
184
189
200
201
202
203
204
208
209
221
222
223
238
239
240
249
251
253
260
267
274
283
292
304
315
326
337
348

 

[Scott Huish]

If you mean you want all those values on a single line separated by commas, then I would suggest this.
Open the file in Word.
Do a Find and Replace:
Find: ^p
Replace: ,
Click on Replace All

If you end up with an ending comma at the end, just delete that.

 

[brooklyn1976]

If you mean you want all those values on a single line separated by commas, then I would suggest this.
Open the file in Word.
Do a Find and Replace:
Find: ^p
Replace: ,
Click on Replace All

If you end up with an ending comma at the end, just delete that.

Thanks for the reply, Scott. I was actually looking for a way to add multiple commas to each line of text.

For example, for the “F” text file, I want a delimiter after the 12th character, 20th character, 26th character, etc. of each line.

Thanks!

 

[Fluff]

Rather than adding a delim, you can use text to columns conversion & select fixed width, then next & set you widths accordingly.

 

[brooklyn1976]

Thanks!! That is exactly what I need. However, there is one issue. The wizard screen (window is titled "Text Import Wizard - Step 2 of 3") only shows 107 characters and I cannot get it to move over to view and edit the data to the right (characters 108 to 300+). Any ideas?

 

[Fluff]

That suggests that you only have ~107 characters, I've just done a test & it shows upto 310

Just checked in 2003 version & that shows upto 260, but has cropped the text.

 

[brooklyn1976]

Rather than adding a delim, you can use text to columns conversion & select fixed width, then next & set you widths accordingly.

Thanks, Fluff. This works like a charm. The solution to the wizard window not scrolling is to turn on the scroll bars in system preferences.

https://answers.microsoft.com/en-us...b4d-ac75-478a-9c1c-6a357029b3ef?page=2&auth=1

Thanks!!

 

[brooklyn1976]

That suggests that you only have ~107 characters, I've just done a test & it shows upto 310

I think the issue is on Mac when you don't have scroll bars to always show. Thanks again.

 

[Fluff]

Glad to help & thanks for the feedback.

Is this something that yo do on a regular basis?