Ask Your Question
0

Base: Query, compound REPLACE function [closed]

asked 2017-07-12 00:00:13 +0100

Joe Castor gravatar image

updated 2017-07-12 00:01:43 +0100

My table has a Boolean cell for "Family" . I want to make a query with a column that says "and Family" if TRUE and " " if FALSE. I tried to create a compound REPLACE function but it didn't work. I can only do one or the other. This query is to provide a CSV file for an external emailing function with other data from the table. Any suggestions for overcoming this? Thank you in advance, Joe

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Joe Castor
close date 2017-07-12 02:10:40.803648

1 Answer

Sort by » oldest newest most voted
1

answered 2017-07-12 00:29:48 +0100

Ratslinger gravatar image

Add to your existing query:

SELECT CASEWHEN("Family" = 'TRUE','and Family', '') SUBSTITUTE FROM "YOUR_TABLE"
edit flag offensive delete link more

Comments

Perfect. Worked Great. Thank you Ratslinger. You continue to help me grow.

Joe Castor gravatar imageJoe Castor ( 2017-07-12 02:00:18 +0100 )edit

If this answers your question please click on the ✔ (upper left area of answer).

Ratslinger gravatar imageRatslinger ( 2017-07-12 02:07:27 +0100 )edit

@Joe Castor First, always glad to help. Questions are always welcome.

While marking a question closed is OK, it can be closed for many different reasons. Marking that a correct answer was provided helps others who are looking for answers to the same or a similar question. This is done in the upper left of the correctly provided answer - see this post.

Ratslinger gravatar imageRatslinger ( 2017-07-12 03:54:35 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2017-07-12 00:00:13 +0100

Seen: 65 times

Last updated: Jul 12 '17