Test for Data Type

Montez659

Well-known Member
Joined
May 4, 2005
Messages
918
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

Well-known Member
Joined
May 4, 2005
Messages
918
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.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,824
Office Version
  1. 2019
Platform
  1. Windows
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

Well-known Member
Joined
Apr 28, 2004
Messages
76,264
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
May 4, 2005
Messages
918
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,205
Messages
5,623,363
Members
415,969
Latest member
Rey99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top