AutoHotkey Community

[stressbaby]

Thanks hugov, your suggestion worked.

[nnah]

I am new to Auto hot key, so please bear with me, I only know the basic right now.

I have a file which has the below information. We will call File A

20100517|L00015099|97001GP|1||||||
20100517|L00014977|97001GP|1||||||
20100517|L00015024|97001GP|1||||||
20100517|L00015081|97530GP|4||||||
20100517|L00014996|97110GP|2||||||
20100517|L00014996|97530GP|1||||||

I need to replace all the information in the second column ex (L00015099) with data from a sample file below which we will call File B

4200010
4200012
4200013
4200020
4200060
4200068

Can someone please start me off...I have this huge file that I need to manipulate and upload into the system before the weekend is over....I really need help.
Thanks,

[Learning one]

Well, if it's urgent - here you are;

[SoLong&Thx4AllTheFish]

Seems more like a job for CSV_ModifyColumn using | as delimiter http://www.autohotkey.com/forum/topic55909.html (and I wouldn't use RegEx here). Or simply do it in Excel or other spreadsheet.
_________________
AHK Wiki FAQ
TF : Text files & strings lib, TF Forum

[SoLong&Thx4AllTheFish]

As proof of concept, you COULD use TF in this case because of the fixed width of the columns (with varying widths of columns you wouldn't succeed, at least not until I add a TF_FixedCol function ;-))

[EdScriptNewbie]

In hopes of DateStamping the first line of a frequently updated file, I attempted to use your library as follows:

[SoLong&Thx4AllTheFish]

The problem is marked in the red lines

[EdScriptNewbie]

I couldn't make

[SoLong&Thx4AllTheFish]

Thanks for pointing out my noob mistake, there goes my credibility

The examples in the documentation are based on the example test script:
http://www.autohotkey.com/forum/viewtopic.php?p=280363#280363
which should provide you with a few examples per TF Function to illustrate its use.

Further reading about variables:
http://www.autohotkey.com/docs/FAQ.htm#percent and a more elaborate one here:
http://www.autohotkey.net/~deleyd/xprxmp/autohotkey_expression_examples.htm
_________________
AHK Wiki FAQ
TF : Text files & strings lib, TF Forum

[EdScriptNewbie]

Trust me, you're way credible still.

I'm feeling my way along, so it doesn't take much to throw me off, and the TF test script seemed to assume somebody more programming-knowledgeable than I. Even little things like

msgbox % myvar

I'd _never_ seen that syntax before and couldn't find it anyplace in the docs. Where do people learn these tricks? I admire and respect that programmers pride themselves in writing the shortest possible code and the most terse comments, but I spend time under water trying to figure it out. The examples seem to have a lot of one-letter variables that seem more like parameters, and multiple different lines with identical comments. or

TF_InsertSuffix("File.txt","2-4,6-9","", " Hello") ; Suffix Hello in lines 2 to 4 and 6 to 9

--> ok, why does it show ,"2-4,6-9", and not ,"2-4","6-9", ...?

Duh stuff to those who know, but I'm not there yet. But enough whinging, as the brits like to say; I _really_ like the expression examples and in five mins learned quite a bit. Also it felt good to see that somebody else finds some of this stuff non-obvious.

Thanks again. I really appreciate the help.
_________________
...Ed

[SoLong&Thx4AllTheFish]

[shyangs]

Does it only support ANSI files?

How to read UTF-8 text files?

[SoLong&Thx4AllTheFish]

I honestly don't know as I only work with the standard AutoHotkey version. You may try the unicode version of AutoHotkey_L but I don't know if the output will be a UTF-8 text if the input is a UTF-8 file. So you'll have to experiment.

If I do work with utf-8 files, I convert them to ansi as done here http://www.autohotkey.com/forum/viewtopic.php?p=287218#287218

This may also be of interest:

[cliendo]

I have the following text:

[30]: 11
[31]: 7
[32]: 25

And I am trying to use TF_RegExReplace() to get rid of the text from ":" till CR+LF and replace them by a comma (,). The purpose is to obtain:

[30],[31],[32]

I couldn't find any PCRE related structure to work out to get the desired outcome. I would like to get rid of the CR+LF at the end so I could have the [30], [31],[32] in the same row.

I couldn't even get rid of the CR+LF at the end of every row.

Could you give me and advice about how to do it?

Rgds,

CL

[Tuncay]

I am not working with the TF-library, so can not provide help on it. But I have here an alternative, however it is not a regex-only solution.