Adding punctuation in a concatenate formula

Hello. I have a dataset in which there are a "year" [string] and a "quarter" [string] column.

I would like to join the two to create a field such as "2010.Q3".

I have tried the following formula, but it returns an error:

[Year" + "." + [Quarter]

I am sure I am doing something very basic here which is wrong (amateur hour at the ol' Chapman place) but any help would be greatly appreciated.

DoC

Workflow

Error Message

Best Practices

Accepted answers

JosephSerpis

Hi @DavidOliverChapman this syntax should work i'm assuming your year is a numeric value and not a string ToString([Year])+"."+[Quarter]

LordNeilLord

Hey @DavidOliverChapman

Try

ToString([Year]) + "." + [Quarter]

All comments

Ladarthure

Hi,

few things, check the length of the new field, and to ensure the year is in a string format, you could use a tostring([year]) it should work!

Hope it helped!

JosephSerpis

Hi @DavidOliverChapman this syntax should work i'm assuming your year is a numeric value and not a string ToString([Year])+"."+[Quarter]

LordNeilLord

Hey @DavidOliverChapman

Try

ToString([Year]) + "." + [Quarter]

DavidOliverChapman

LordNeilLordLadarthur

Thanks guys for the quick response.

I have tried both solutions, and both work really well.

Re. Year as a number field. I had created the "Year" field from a date column (2010-06-22), using a text to columns function. I had formatted the date field, and the resulting three columns, as "String". Would it be "best practice" to format these as numeric fields?

Again - thanks for the quick response. Much appreciated.

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235