HomeForum
Welcome, Guest

using the function SubString
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: using the function SubString

using the function SubString 1 year, 1 month ago #2525

  • Rob
  • OFFLINE
  • Fresh Boarder
  • Posts: 9
  • Karma: 0
What would be the correct function syntax to use if I want to populate a field on a MySQL table with the three first character of the row on a Excel spread sheet.
I'm using ODBC to connect to MySQL table.
As shown on the image below I tried using the function "SubString([PHONE],1,3):[PHONE]" but it does not seem to work in neither Mapping Type (Calculate or SQL Statement).
I will appreciate your assistance on this matter.

Thanks
Robert
Attachments:

Re: using the function SubString 1 year, 1 month ago #2526

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
It should be SubString([PHONE],1,3)

not "SubString([PHONE],1,3):[PHONE]"

Mike
  • Page:
  • 1
Time to create page: 0.16 seconds

Testimonials

We had two thousands text files in same format. We were able to load them in one click using Visual Importer ETL.

Pol Barret,
Accountant

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top