Test for Data Type

[Montez659]

Is there a way to test a piece of data to see if it is a string (or has the potential to be a string) or an integer (or the potential to be an integer)?

I am pulling lines from a text file and there is no easy way to delimit the data so I am having to split the line based on different characters (like "-", and ".") and hopefully be able to test the data type potential to get the values that I need.

Thanks in advance, and Happy Thanksgiving to my USA peeps!

 

[Montez659]

Yeah, the only purpose of the statement is to reconcile automatically. I tried to do a download of transaction history as well, but if I am not mistaken, that was in PDF format and had some quirks about it just like the statement did when I transferred it to text.

I will definitely need to check out Notepad++ though.

 

[xenou]

I'm a huge fan.
Consider putting some sample data up (suitably cleansed of private information). You might get some more ideas about how to "parse" the data even if it is on multiple lines and so on.

ξ

 

[Norie]

Have you tried any other ways to convert PDF to text?

There's plenty of 'free' applications out there that purport to do it.

Some of them might even work.

 

[Montez659]

Let me get some of the data "cleansed" and then I will post it.

Right now, I have Acrobat 7(? - not sure which version, or if it really is Acrobat for that matter. I'm on my laptop at mom's for Turkey Day ) to do the conversion. I haven't really tried any of the free programs out there as I hoped that Acrobat would really be the best program to convert PDF's, but I will definitely check some out and see if I get a different result.